Using custom scripts

Custom scripts are T-SQL scripts that you can choose to run either before (pre-sync) or after the synchronization (post-sync) against the target database. They must exist on the client machine where the package runs. You can choose to run a single file or the entire set of files in a folder. When a script folder is selected, the builder runs all the files with .sql extension in the specified folder in alphabetical order.

The following rules apply to the custom scripts:

The entire set of pre-sync/post-sync scripts is executed in one single transaction. If one of them fails, the entire set is rolled back and the process stops.
If a custom script contains multiple batches, separated by "GO", batches are executed one at a time within the same transaction. If a batch fails, the entire set of custom scripts is rolled back and the process stops.

This behavior is defined in the code template which is provided with xSQL Builder. You can change it to accommodate your comparison scenario.